inherited fmExcelUnitySiparisAktarim: TfmExcelUnitySiparisAktarim
  Tag = 603
  Left = 292
  Top = 197
  Caption = 'Excelden Unity e Sipari'#351' Aktar'#305'm'#305
  ClientHeight = 407
  ClientWidth = 855
  KeyPreview = True
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Panelx: TPanel [0]
    Left = 0
    Top = 373
    Width = 855
    Height = 34
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 2
    DesignSize = (
      855
      34)
    object bkapat: TBitBtn
      Left = 773
      Top = 4
      Width = 76
      Height = 25
      Anchors = [akTop, akRight]
      Caption = '&Kapat'
      TabOrder = 4
      OnClick = bkapatClick
    end
    object btYeni: TBitBtn
      Left = 4
      Top = 5
      Width = 77
      Height = 27
      Action = acEkle
      BiDiMode = bdLeftToRight
      Caption = 'Ekle'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentBiDiMode = False
      ParentFont = False
      ParentShowHint = False
      ShowHint = True
      TabOrder = 0
      NumGlyphs = 2
      Spacing = 2
    end
    object btSil: TBitBtn
      Left = 84
      Top = 5
      Width = 77
      Height = 27
      Action = acSil
      Caption = 'Sil'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      ParentShowHint = False
      ShowHint = True
      TabOrder = 1
      NumGlyphs = 2
      Spacing = 2
    end
    object btDuzelt: TBitBtn
      Left = 165
      Top = 5
      Width = 77
      Height = 27
      Action = acGuncelle
      Caption = 'G'#252'ncelle'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      ParentShowHint = False
      ShowHint = True
      TabOrder = 2
      NumGlyphs = 2
      Spacing = 2
    end
    object btIncele: TBitBtn
      Left = 246
      Top = 5
      Width = 77
      Height = 27
      Action = acincele
      Caption = #304'ncele'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      ParentShowHint = False
      ShowHint = True
      TabOrder = 3
      NumGlyphs = 2
      Spacing = 2
    end
  end
  object GroupBox1: TGroupBox [1]
    Left = 0
    Top = 0
    Width = 855
    Height = 75
    Align = alTop
    Caption = '  Arama Kriterleri  '
    TabOrder = 0
    object Label1: TLabel
      Left = 12
      Top = 26
      Width = 37
      Height = 14
      Caption = 'Durumu'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label8: TLabel
      Left = 223
      Top = 26
      Width = 44
      Height = 14
      Caption = 'Firma Ad'#305
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label3: TLabel
      Left = 11
      Top = 47
      Width = 25
      Height = 14
      Caption = 'Tarihi'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label2: TLabel
      Left = 223
      Top = 48
      Width = 52
      Height = 14
      Caption = 'Sipari'#351' Tipi'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label4: TLabel
      Left = 489
      Top = 26
      Width = 49
      Height = 14
      Caption = 'Sipari'#351' No'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label5: TLabel
      Left = 489
      Top = 48
      Width = 43
      Height = 14
      Caption = 'Belge No'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object btListele: TBitBtn
      Left = 643
      Top = 21
      Width = 99
      Height = 44
      Action = acListele
      Caption = 'Listele'
      TabOrder = 7
    end
    object dtBasTarih: TwwDBDateTimePicker
      Left = 59
      Top = 45
      Width = 74
      Height = 21
      AutoFillDateAndTime = True
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      Epoch = 1950
      ShowButton = True
      TabOrder = 1
    end
    object cbDurum: TwwDBComboBox
      Left = 59
      Top = 23
      Width = 150
      Height = 21
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'Unity e Aktar'#305'lmam'#305#351#9'1'
        'Unity e Aktar'#305'ld'#305#9'3')
      ItemIndex = 0
      Sorted = False
      TabOrder = 0
      UnboundDataType = wwDefault
    end
    object dtBitTarih: TwwDBDateTimePicker
      Left = 134
      Top = 45
      Width = 74
      Height = 21
      AutoFillDateAndTime = True
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      Epoch = 1950
      ShowButton = True
      TabOrder = 2
    end
    object edSiparisNo: TwwDBEdit
      Left = 542
      Top = 23
      Width = 84
      Height = 21
      TabOrder = 5
      UnboundDataType = wwDefault
      WantReturns = False
      WordWrap = False
    end
    object edBelgeNo: TwwDBEdit
      Left = 542
      Top = 45
      Width = 84
      Height = 21
      TabOrder = 6
      UnboundDataType = wwDefault
      WantReturns = False
      WordWrap = False
    end
    object cbSiparisTipi: TwwDBComboBox
      Left = 281
      Top = 48
      Width = 154
      Height = 21
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DataField = 'SiparisTipi'
      DataSource = dsEntry
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'Dolar Sipari'#351#9'Dolar/Dolar/Dolar'
        'TL Sipari'#351#9'TL/TL/TL'
        'Dolar Sipari'#351' Sabit Kur'#9'DolarS/TL/TL')
      Sorted = False
      TabOrder = 4
      UnboundDataType = wwDefault
    end
    object cbFirmaAdi: TwwDBLookupComboDlg
      Left = 281
      Top = 26
      Width = 154
      Height = 21
      DisableThemes = False
      GridOptions = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgPerfectRowFit]
      GridColor = clWhite
      GridTitleAlignment = taLeftJustify
      Caption = 'Firma Ad'#305
      MaxWidth = 0
      MaxHeight = 209
      Selected.Strings = (
        'FirmaAdi'#9'30'#9'Firma Ad'#305#9'F'
        'Carikodu'#9'20'#9'Carikodu'#9#9)
      LookupTable = aqCariler
      LookupField = 'Carikod'
      Style = csDropDownList
      TabOrder = 3
      AutoDropDown = True
      ShowButton = True
      AllowClearKey = True
      UseTFields = False
    end
  end
  object s: TcxGrid [2]
    Left = 0
    Top = 75
    Width = 855
    Height = 298
    Align = alClient
    PopupMenu = pmAktar
    TabOrder = 1
    LookAndFeel.NativeStyle = True
    object grdListe: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      OnCellDblClick = grdListeCellDblClick
      DataController.DataSource = dsEntry
      DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
      DataController.Summary.DefaultGroupSummaryItems = <
        item
          Format = '#######'
          Kind = skCount
          FieldName = 'SeriNo'
        end
        item
          Format = '######'
          Kind = skCount
          FieldName = 'Carikod'
        end>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      FilterRow.InfoText = '  '
      FilterRow.ApplyChanges = fracImmediately
      OptionsBehavior.IncSearch = True
      OptionsCustomize.ColumnFiltering = False
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Editing = False
      OptionsData.Inserting = False
      OptionsSelection.UnselectFocusedRecordOnExit = False
      OptionsView.NoDataToDisplayInfoText = '  '
      OptionsView.Indicator = True
      Styles.StyleSheet = dm.tvssDevExpress
      object grdListeRef: TcxGridDBColumn
        Caption = 'Fi'#351' No'
        DataBinding.FieldName = 'Ref'
        Width = 38
      end
      object grdListeSiparisTipi: TcxGridDBColumn
        Caption = 'Sipari'#351' Tipi'
        DataBinding.FieldName = 'SiparisTipi'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Items = <
          item
            Description = 'Dolar Sipari'#351
            ImageIndex = 0
            Value = 'Dolar/Dolar/Dolar'
          end
          item
            Description = 'TL Sipari'#351
            Value = 'TL/TL/TL'
          end
          item
            Description = 'Dolar Sipari'#351' Sabit Kur'
            Value = 'DolarS/TL/TL'
          end>
        Width = 114
      end
      object grdListeTarih: TcxGridDBColumn
        DataBinding.FieldName = 'Tarih'
        Width = 74
      end
      object grdListeCariKodu: TcxGridDBColumn
        DataBinding.FieldName = 'CariKodu'
        Width = 110
      end
      object grdListeFirmaAdi: TcxGridDBColumn
        Caption = 'Firma Ad'#305
        DataBinding.FieldName = 'FirmaAdi'
        Width = 174
      end
      object grdListeBelgeNo: TcxGridDBColumn
        Caption = 'Belge No'
        DataBinding.FieldName = 'BelgeNo'
        Width = 80
      end
      object grdListeOdemeSekli: TcxGridDBColumn
        Caption = #214'deme '#350'ekli'
        DataBinding.FieldName = 'OdemeSekli'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.KeyFieldNames = 'LOGICALREF'
        Properties.ListColumns = <
          item
            FieldName = 'CODE'
          end>
        Properties.ListSource = dsOdemeler
      end
      object grdListeProjeid: TcxGridDBColumn
        Caption = 'Proje Kodu'
        DataBinding.FieldName = 'Projeid'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.KeyFieldNames = 'LOGICALREF'
        Properties.ListColumns = <
          item
            FieldName = 'CODE'
          end>
        Properties.ListSource = dsProjekodu
        Width = 80
      end
      object grdListeDurum: TcxGridDBColumn
        DataBinding.FieldName = 'Durum'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Items = <
          item
            Description = 'Unity e Aktar'#305'lmad'#305
            ImageIndex = 0
            Value = 1
          end
          item
            Description = 'Unity e Aktar'#305'ld'#305
            Value = 3
          end>
        Width = 96
      end
      object grdListeAciklama1: TcxGridDBColumn
        Caption = 'A'#231#305'klama -1'
        DataBinding.FieldName = 'Aciklama1'
        Width = 150
      end
      object grdListeAciklama2: TcxGridDBColumn
        Caption = 'A'#231#305'klama -2'
        DataBinding.FieldName = 'Aciklama2'
        Width = 150
      end
      object grdListeAciklama3: TcxGridDBColumn
        Caption = 'A'#231#305'klama -3'
        DataBinding.FieldName = 'Aciklama3'
        Width = 150
      end
      object grdListeAciklama4: TcxGridDBColumn
        Caption = 'A'#231#305'klama -4'
        DataBinding.FieldName = 'Aciklama4'
        Width = 150
      end
    end
    object cxGridLevel2: TcxGridLevel
      GridView = grdListe
    end
  end
  inherited alKeyControl: TActionList
    Left = 833
    Top = 299
    object acEkle: TAction
      Tag = 1001
      Caption = 'Ekle'
      ShortCut = 119
      OnExecute = acEkleExecute
    end
    object acSil: TAction
      Tag = 1002
      Caption = 'Sil'
      ShortCut = 16498
      OnExecute = acSilExecute
    end
    object acGuncelle: TAction
      Tag = 1003
      Caption = 'G'#252'ncelle'
      ShortCut = 118
      OnExecute = acGuncelleExecute
    end
    object acListele: TAction
      Caption = 'Listele'
      ShortCut = 116
      OnExecute = acListeleExecute
    end
    object acincele: TAction
      Caption = #304'ncele'
      ShortCut = 120
      OnExecute = acinceleExecute
    end
  end
  inherited XPManifest: TXPManifest
    Left = 832
    Top = 249
  end
  object dsEntry: TDataSource
    DataSet = aqEntry
    Left = 248
    Top = 261
  end
  object aqEntry: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      'Select S.*'
      ',Depo=(Select DepoAdi From Depolar Where id=s.Depokod)'
      ',CariKodu=(C.Carikodu),FirmaAdi=(C.FirmaAdi)'
      ' from TblExcelSiparis S'
      'join Cari C on (S.Carikod=C.Carikod)')
    Left = 249
    Top = 211
  end
  object pmAktar: TPopupMenu
    OnPopup = pmAktarPopup
    Left = 148
    Top = 149
    object UnityeAktar1: TMenuItem
      Caption = 'Unity e Aktar'
      OnClick = UnityeAktar1Click
    end
  end
  object aqCariler: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      'Select * From tblUnitySiparisAktarimCari'
      'Order By FirmaAdi')
    Left = 180
    Top = 232
  end
  object aqProjekodu: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      
        'SELECT  LGMAIN.LOGICALREF, LGMAIN.CODE, LGMAIN.NAME, LGMAIN.SPEC' +
        'ODE, LGMAIN.ACTIVE, LGMAIN.CYPHCODE  FROM  LG_021_PROJECT LGMAIN' +
        ' WITH(NOLOCK, INDEX = I021_PROJECT_I4)   WHERE  (LGMAIN.ACTIVE =' +
        ' 0) ORDER BY  LGMAIN.ACTIVE, LGMAIN.CODE')
    Left = 77
    Top = 179
  end
  object dsProjekodu: TDataSource
    DataSet = aqProjekodu
    Left = 76
    Top = 227
  end
  object aqOdemeler: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    CommandTimeout = 300
    Parameters = <>
    SQL.Strings = (
      
        'SELECT LGMAIN.LOGICALREF, LGMAIN.CODE, LGMAIN.DEFINITION_, LGMAI' +
        'N.ACTIVE, LGMAIN.SPECODE, LGMAIN.EARLYINTEREST, LGMAIN.LATEINTER' +
        'EST, LGMAIN.ORGLOGICREF  FROM  LG_021_PAYPLANS LGMAIN WITH(NOLOC' +
        'K, INDEX = I021_PAYPLANS_I3)   WHERE  (LGMAIN.ACTIVE = 0) ORDER ' +
        'BY  LGMAIN.ACTIVE, LGMAIN.CODE')
    Left = 110
    Top = 179
  end
  object dsOdemeler: TDataSource
    DataSet = aqOdemeler
    Left = 108
    Top = 227
  end
end
